﻿CREATE PROCEDURE [dbo].[friends_get_request]
    @userId int
AS
    SELECT 
        Users.Avatar,
        Users.Login,
        Users.UserId
    FROM Users,Friends
    WHERE Friends.UserId = @userId and Users.UserId = Friends.FriendId and Friends.IsAccepted = 0
RETURN 0
